|
|
| Book details / order |
| SQL & PL/SQL FOR ORACLE 11G BLACK BOOK |
This book, sql & pl/sql black book, brings to you the complete, latest account of sql and pl/sql for oracle. it gifts you two things-first, it upgrades your knowledge on the subject; and second the innumerable, exciting examples help you build a better skill in sql and pl/sql.
the highlight of the book is a clear yet incisive discussion of the basic features of oracle 9i and the latest advanced features that come with oracle 10g. the in-depth treatment of the subject in a lucid language will give you an enjoyable learning experience as you have always had with our previous books on oracle.
this comprehensive reference will help you learn the entire spectrum of sql-from views to cube and roll up; from case expressions to variances and correlation-and pl/sql-from collections to object types; from error handling to triggers; from object views to rollback segments; from undo tablespace to expression filter, and many more. all this, as the book zips through the material and does not blather on or repeat points made earlier-no doubt, every aspect is worth the price of the entire book.
-----------------------------------------------------------------------------------------------------------
unit - i: sql
? introduction to sql
? set operations
? sql operators
? aggregate functions and group by clause
? updating and deleting data in existing table (dml)
? views
? assignment-i
? assignment-ii
? advanced queries
? integrity constraints
? analytical queries
? understanding rollup and cube
? understanding joins
? scalar subqueries
? case expressions
? multitable insert and merge
? regular expression
? statistical functions
? model queries
? sql quiz
unit - ii: pl/sql
? pl/sql program features
? pl/sql datatypes
? understanding control structure
? interaction with oracle
? collections and records
? lob, bfile, and dbms_lob
? objects and object types
? sample programs-i
? sample programs-ii
? error handling
? subprograms in pl/sql
? package
? trigger (database)
? autonomous transaction
? important pl/sql packages
? object views
? transaction processing in oracle
? locking in oracle
? rollback segments
? undo tablespace
? invoker rights and nocopy clause
? dependency tracking in oracle
? flashback queries
? sequence
? pl/sql wrapper
? oracle expression filter
? server model for bill entry system
? security and auditing
? pl/sql questions
appendix a: tables
index
Author : P.s.deshpande
Publication : Black book
Isbn : 9788177229400
Store book number : 107
NRS 1120.00
|
 |
|
|
|
|
|
|
|
| |
|
|
